package myJlite.mapper;

import java.util.List;

import myJlite.entity.ExamVO;

import org.apache.ibatis.annotations.Param;

public interface UserMapper {
//	@Insert("INSERT INTO user (name, age, gender, experience) VALUES (#{name}, #{age}, #{gender}, #{experience})")
//	@Options(useGeneratedKeys = true, keyProperty = "id")
//	int createUser(ExamVO user);
//
//	@Insert("INSERT INTO user_interest (user_id, interest_id) VALUES (#{userId}, #{interestId})")
//	int createUserInterest(@Param("userId") int userId,
//			@Param("interestId") int interestId);
//
//	@Delete("DELETE FROM user WHERE id = #{id}")
//	int deleteUser(int id);
//
//	@Delete("DELETE FROM user_interest WHERE user_id = #{userId}")
//	int deleteUserInterest(int userId);

	// findUsers(String, int) 的执行策略定义在 UserMapper.xml 中
	List<ExamVO> findUsers(@Param("username") String username,
			@Param("sex") Boolean sex);

//	@Select("SELECT interest_id FROM user_interest WHERE user_id = #{userId} ORDER BY id")
//	List<Integer> findUserInterests(int userId);
//
//	// queryInterest(int, int) 的执行策略定义在 UserMapper.xml 中
//	List<ExamVO> queryInterest(@Param("gender") int gender,
//			@Param("experience") int experience);
}
